//验证数据库中的用户相关内容
const User = {
	//查询用户手机号
	queryUserTel( option ){
		
		return 'select * from users where tel = '+option.userTel+''
			
	},
	// 查询密码
	queryUserPwd( option ){
		return 'select * from users where (tel = '+option.userTel+') and pwd = '+option.userPwd+''
	},
	// 新增用户
	inserData( option ){
		let userTel = option.userTel
		let userPwd = option.userPwd || '666666'

		//引入token包
        let jwt = require('jsonwebtoken');
        //用户信息
        let payload = {tel:userTel};
        //口令
        let secret = 'xiaoluxian';
        //生成token
        let token = jwt.sign(payload,secret);
		
		// console.log( 'insert into users (tel,pwd,imgUrl,inckName,token) values ("'+userTel+'","'+userPwd+'","/images/user.jpeg","'+userTel+'","'+token+'")' );

		
		return 'insert into users (tel,pwd,imgUrl,inckName,token) values ("'+userTel+'","'+userPwd+'","/images/user.jpeg","'+userTel+'","'+token+'")';
	}
}
exports = module.exports = User













